Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12 <meta charset="utf-8">
13 <meta name="viewport" content="width=device-width, initial-scale=1.0">
14 <title>school management system</title>
15 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
17 <link href="assets/css/loader.css" rel="stylesheet" />
18 <script src="assets/js/canvasjs.min.js"></script>
19 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
20 <script src="assets/js/jquery-3.2.1.js"></script>
21
22 <!--***************the year search text box*************************************************-->
23 <script>
24 function myFunction() {
25 // Declare variables
26 var input, filter, table, tr, td, i;
27 input = document.getElementById("myInput");
28 filter = input.value.toUpperCase();
29 table = document.getElementById("myTable");
30 tr = table.getElementsByTagName("tr");
31
32 // Loop through all table rows, and hide those who don't match the search query
33 for (i = 0; i < tr.length; i++) {
34 td = tr[i].getElementsByTagName("td")[1];
35 if (td) {
36 if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
37 tr[i].style.display = "";
38 } else {
39 tr[i].style.display = "none";
40 }
41 }
42 }
43 }
44 </script>
45 <!--***************the year search text box*************************************************-->
46 <script>
47 function myFunction2() {
48 // Declare variables
49 var input, filter, table, tr, td, i;
50 input = document.getElementById("myInput2");
51 filter = input.value.toUpperCase();
52 table = document.getElementById("myTable");
53 tr = table.getElementsByTagName("tr");
54
55 // Loop through all table rows, and hide those who don't match the search query
56 for (i = 0; i < tr.length; i++) {
57 td = tr[i].getElementsByTagName("td")[2];
58 if (td) {
59 if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
60 tr[i].style.display = "";
61 } else {
62 tr[i].style.display = "none";
63 }
64 }
65 }
66 }
67 </script>
68
69
70 </head>
71
72 <body >
73 <!--end of heading section-->
74 <ul class="nav navbar-right top-nav">
75 <div class="dropdown">
76 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
77 <?php
78 //Check to see if the user is logged in.if not redirect user to the loging page.
79
80 if(isset($_SESSION['fname']))
81 {
82 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
83 }else{
84 echo "<script type='text/javascript'>
85 alert( 'You must Log in to use the system');
86 </script>";
87 echo "<script>
88 window.location = 'index.php'
89 </script>";
90 }
91 ?>
92 <span class="caret"></span></button>
93 <ul class="dropdown-menu">
94 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
95 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
96 <li class="divider"></li>
97 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
98 </ul>
99 </div>
100 </ul>
101 <!--************************************************-->
102 <div style="
103 font-family:Nyala, Arial;
104 text-align: left;
105 background-color: #526F35;
106 padding: 20px;
107 color:white;
108 width: 100%;
109 height: 150px;">
110 <!--This codes to load the image loader-->
111 <div id="loading">
112 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
113 </div>
114 <!--this is the heading section-->
115 <h2>
116 <?php
117 $sql="SELECT * FROM companyinfo";
118 $result=mysqli_query($db,$sql) or die("error getting data");
119 $num_rows=mysqli_num_rows($result);
120 while($row=mysqli_fetch_array($result))
121 {
122 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
123 $cname = $row['cname'];
124 $cemail = $row['cemail'];
125 $ccontact = $row['ccontact'];
126 $clocation = $row['clocation'];
127 }?>
128 <?php
129 echo $cname;
130 ?>
131
132 <div style="float:right; font-size:20px;text-align:right;">
133
134 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
135 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
136 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
137
138 </div>
139 </h2>
140 </div>
141 <!--end of heading section-->
142
143 <div>
144 <ul class="nav nav-tabs">
145 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
146 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
147 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
148 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
149 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
150 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
151 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
152 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
153 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
154 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
155
156 </ul>
157 <div class="tab-content">
158 <div class="tab-pane active" role="tabpanel" id="tab-1">
159
160 <p>
161 <div class="table-responsive" >
162 <!--****************************************************************************-->
163 <div class="container" style="width:100%">
164
165 <ul class="nav nav-tabs">
166 <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
167 <li><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
168 <li class="active"><a href="viewstudentsedit1.php">Edit Student<img src="assets/img/view2.png"></a></li>
169 <li><a href="csvstudents.php">Import/Export Data <img src="assets/img/import.png"></a></li>
170 <li><a href="reports_students.php">Reports </a></li>
171 </ul>
172 <br>
173
174 </div>
175
176 <!--*************************************************************************************************************************-->
177 <div id="page-wrapper">
178 <div class="container-fluid">
179
180
181 <!-- Page Heading -->
182 <nav>
183 <?php
184 $id = $_GET['id'];
185
186 $sql ="SELECT * from course where course_id=$id";
187 $user_query=mysqli_query($db,$sql) or die("error getting data");
188 while($row = mysqli_fetch_array($user_query)){
189 $id = $row['course_id'];
190 $coursename = $row['coursename'];
191 $fee = $row['feepayable'];
192 }
193 ?>
194 <center><h4><strong>Students Form, Course: <?php echo $coursename; ?> fee payable <?php echo $fee; ?></strong><h4></center>
195
196
197 <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
198 <div class="modal-dialog">
199 <div class="modal-content">
200 <div class="modal-header">
201 <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
202 <h4 class="modal-title" id="myModalLabel">Confirmation</h4>
203 </div>
204 <div class="modal-body">
205 Are you to sure you want to delete this?
206 </div>
207 <div class="modal-footer">
208 <form method = "POST">
209 <input type="submit" name="delete" value = "Delete" class="btn btn-danger">
210
211 <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
212
213 </div>
214 </div>
215 </div>
216 </div>
217 <?php
218 if(isset($_POST['delete'])){
219 $id=$_POST['selector'];
220
221 $N = count($id);
222 for($i=0; $i < $N; $i++)
223 {
224 $result = mysqli_query("DELETE FROM studentstable where admission_number='$id[$i]'");
225 }
226 }
227 ?>
228 <!-- block -->
229 <div id="block_bg" class="block">
230 <div class="navbar navbar-inner block-header">
231
232 <table>
233 <tr>
234 <td><a button type='button' class="btn btn-primary" href="viewstudentrecord.php"><--</a></td>
235 <td><a button type='button' class="btn btn-primary glyphicon glyphicon-print" href="#"></a></td>
236 <td><label>Search using Admission number</label></td>
237 <td><input type="text" name="myInput" id="myInput" class="form-control"
238 placeholder="Adm no" onkeyup="myFunction()"></td>
239 <td><label>Name</label></td>
240 <td><input type="text" name="myInput2" id="myInput2" class="form-control"
241 placeholder="Name" onkeyup="myFunction2()"></td></tr></table>
242
243
244 <div class="block-content collapse in">
245 <div class="span12">
246
247 <form method="post">
248 <div class="table-responsive">
249 <table cellpadding="0" cellspacing="0" border="0" class="table" id="myTable" >
250
251 <thead>
252 <tr>
253 <th></th>
254 <th><center>Adm No.</center></th>
255 <th><center>Name</center></th>
256 <th><center>Gender</center></th>
257 <th><center>Email Address</center></th>
258 <th><center>Mobile</center></th>
259 <th><center>Address</center></th>
260 <th><center>Reg. Date</center></th>
261 <th><center>Edit</center></th>
262 <th><center>View Parent</center></th>
263 <script src="assets/js/jquery.dataTables.min.js"></script>
264 <script src="assets/js/DT_bootstrap.js"></script>
265 <th></th>
266 </tr>
267 </thead>
268 <tbody>
269 <?php
270 $id=$_GET['id'];
271
272 $sql ="SELECT * from studentstable where course_id=$id";
273 $user_query=mysqli_query($db,$sql) or die("error getting data");
274 while($row = mysqli_fetch_array($user_query)){
275 $id = $row['admission_number'];
276
277 ?>
278 <tr>
279 <td width="30">
280 <input id="optionsCheckbox" class="uniform_on" name="selector[]" type="checkbox" value="<?php echo $id; ?>">
281 </td>
282 <td><center><?php echo $row['admission_number']; ?></center></td>
283 <td><center><?php echo $row['sirname']." ".$row['firstname']." ".$row['lastname']; ?></center></td>
284 <td><center><?php echo $row['gender']; ?></center></td>
285 <td><center><?php echo $row['email']; ?></center></td>
286
287 <td><center><a href="sms.php <?php echo '?id='.$id; ?>" class="btn btn-link">
288 <?php echo $row['mobile']; ?>
289 </a></center></center></td>
290
291 <td><center><?php echo $row['address']."-".$row['zipcode']; ?></center></td>
292 <td><center><?php echo $row['reg_date']; ?></center></td>
293
294 <td>
295 <center><a href="viewstudentsedit1.php <?php echo '?id='.$id; ?>" class="btn btn-success"><i class="glyphicon glyphicon-pencil"></i>Edit</a></center></td>
296
297 <td>
298 <center><a href="parents.php <?php echo '?id='.$id; ?>" class="btn btn-primary"><i class="glyphicon glyphicon-eye-open"></i>View</a></center></td>
299
300
301 </tr>
302 <?php } ?>
303 </tbody>
304 </table>
305 </form>
306
307 </div>
308 </div>
309 </div>
310 </div>
311 <!-- /.container-fluid -->
312
313 </div>
314 <!-- /#page-wrapper -->
315 </div>
316 <!--*********************************************************************************-->
317 <div class="col-md-12" style="background-color:#526F35; bottom:0px;position:fixed;">
318 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
319 </div>
320 <script src="assets/js/jquery.min.js"></script>
321 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
322 <script src="assets/js/affix.js"></script>
323 <script src="assets/js/alert.js"></script>
324 <script src="assets/js/alert1.js"></script>
325 <script src="assets/js/bootstrap.js"></script>
326 <script src="assets/js/bootstrap.min.js"></script>
327 <script src="assets/js/bootstrap-datepicker.js"></script>
328 <script src="assets/js/bootstrap-wysihtml5.js"></script>
329 <script src="assets/js/button.js"></script>
330 <script src="assets/js/carousel.js"></script>
331 <script src="assets/js/chosen.jquery.min.js"></script>
332 <script src="assets/js/ckeditor.js"></script>
333 <script src="assets/js/collapse.js"></script>
334 <script src="assets/js/color.js"></script>
335 <script src="assets/js/dropdown.js"></script>
336 <script src="assets/js/DT_bootstrap.js"></script>
337 <script src="assets/js/dynamic.js"></script>
338 <script src="assets/js/ie-emulation-modes-warning.js"></script>
339 <script src="assets/js/jquery.dataTables.js"></script>
340 <script src="assets/js/jquery.dataTables.min.js"></script>
341 <script src="assets/js/jquery.dialog.js"></script>
342 <script src="assets/js/jquery.hoverdir.js"></script>
343 <script src="assets/js/jquery.jgrowl.js"></script>
344 <script src="assets/js/jquery.knob.js"></script>
345 <script src="assets/js/jquery.uniform.min.js"></script>
346 <script src="assets/js/jquery-1.8.3.min.js"></script>
347 <script src="assets/js/jquery-1.9.1.js"></script>
348 <script src="assets/js/jquery-1.9.1.min.js"></script>
349 <script src="assets/js/jquery-1.10.2.js"></script>
350 <script src="assets/js/jquery-1.11.0.js"></script>
351 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
352 <script src="assets/js/jquery-ui-1.10.3.js"></script>
353 <script src="assets/js/modal.js"></script>
354 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
355 <script src="assets/js/myjquery.js"></script>
356 <script src="assets/js/myjquery1.js"></script>
357 <script src="assets/js/npm.js"></script>
358 <script src="assets/js/popover.js"></script>
359 <script src="assets/js/profile.js"></script>
360 <script src="assets/js/raphael-min.js"></script>
361 <script src="assets/js/sb-admin-2.js"></script>
362 <script src="assets/js/scripts.js"></script>
363 <script src="assets/js/scrollspy.js"></script>
364 <script src="assets/js/tab.js"></script>
365 <script src="assets/js/tooltip.js"></script>
366 <script src="assets/js/transition.js"></script>
367 <script src="assets/js/wysihtml5-0.3.0.js"></script>
368 <script language="javascript" type="text/javascript">
369 $(window).load(function()
370 {
371 $('#loading').hide();
372 });
373 </script>
374 </body>
375
376 </html>